How to: Create a form using Form Wizard using more than one table or query.
Solution:
Click the 'Forms' tab in the Database window, click 'New', select 'Form Wizard', and follow the steps in the wizard.
1) If the Database window is not active, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Click 'New'. (The New Form dialog box appears.)
4) Select 'Form Wizard' from the list box.
5) Click 'OK'. (The Form Wizard dialog box appears.)
6) Select the first table or query from the 'Tables/Queries' drop-down list box.
NOTE: Use the scroll bar for more selections if necessary.
Click Table/Queries from the Form Wizard.
7) Select the desired fields to include on the form from the table or query selected in step 6):
a) Select a field from the 'Available Fields' list box.
b) Click '>'. (The field name appears in the Selected Fields list box.)
c) Repeat steps 7)a) and 7)b) for each field to include on the form.
Select the desired field.
8) Repeat steps 6) and 7) for each table or query to use for the form.
9) Click 'Next'.
10) Select the desired radio button for the form layout. (A preview of the form appears to the left of the radio buttons.)
Select the form layout.
11) Click 'Next'.
12) Select the desired style for the form from the list box. (A preview of the style appears to the left.)
NOTE: Styles from which to choose include: Clouds, Colorful 1, Colorful 2, Dusk, Evergreen, Flax, International, Pattern, Standard, and Stone.
Select a style of the printed form.
13) Click 'Next'.
14) Type a title for the form in the 'What title do you want for your form?' box.
NOTE: If a title is not typed, the name of the table or query used to create the form is used as the form name.
15) Do one of the following:
a) Select the 'Open the form to view or type information' radio button to view the form or type data.
b) Select the 'Modify the form's design' radio button to open the form in the Design view.
Type a form title and select radio button.
16) Click 'Finish'. (The new form appears in either Form view or Design view, depending on the radio button selected in step 15).)